OVI-3: A NoSQL visual query system supporting efficient anti-joins

Abstract The aim of this work was to develop a technique speed up complex joins in an incremental visual query system. When designing visual, highly interactive interface for ad-hoc (read-only) queries, fast response times are paramount importance. While column-oriented DBMS reduces the inherent latency found relational DBMS, there is still question how index data, especially so as support joins. Equi-joins that involve many-to-many relationship example arise frequently and whose efficient processing essential processing. We present OVI-3, NoSQL system based on querying uses simple directory-based indexing scheme faster such has been piloted using real data from student database at Aalto University. results demonstrated certain presented outperforms SQL queries server, involving anti-joins (negation), where OVI-3 provided orders magnitude improvement.